using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
using ReflectionStudio.Core.Events;
using System;

namespace WPFExcelReport
{

    public partial class VWGBST
    {
        public void SetUpNewRow(ref DataRow dwReturn)
        {
            #region=========
            #endregion
            switch (app.company)
            {
                default:
                case "YGR":
                case "TST":
                case "SXN":
                case "UBT":
                    #region=========
                    dwReturn["WGMANDANT"] = app.Mandant;
                    dwReturn["WGSA"] = "00";
                    dwReturn["WGKUNDNR"] = "00000000";
                    dwReturn["WGWERK"] = "   ";
                    dwReturn["WGABT"] = "   ";
                    dwReturn["WGWAKZ"] = "F";
                    dwReturn["WGART"] = "TEST5               ";
                    dwReturn["WGDESS"] = "          ";
                    dwReturn["WGCOLORIT"] = "          ";
                    dwReturn["WGFARBE"] = "          ";
                    dwReturn["WGBESCHICH"] = "          ";
                    dwReturn["WGVAR"] = "  ";
                    dwReturn["WGZUSTAND"] = "    ";
                    dwReturn["WGZENSUR"] = "1";
                    dwReturn["WGZENSURKZ"] = "A";
                    dwReturn["WGLO"] = "01";
                    dwReturn["WGMJJ"] = "0";
                    dwReturn["WGMM"] = "  ";
                    dwReturn["WGAKTKZ"] = "A";
                    dwReturn["WGME01"] = "0";
                    dwReturn["WGME01KG"] = "0";
                    dwReturn["WGME10"] = "0";
                    dwReturn["WGME10KG"] = "0";
                    dwReturn["WGME11"] = "0";
                    dwReturn["WGME11KG"] = "0";
                    dwReturn["WGME12"] = "0";
                    dwReturn["WGME12KG"] = "0";
                    dwReturn["WGME13"] = "0";
                    dwReturn["WGME13KG"] = "0";
                    dwReturn["WGME14"] = "0";
                    dwReturn["WGME14KG"] = "0";
                    dwReturn["WGME15"] = "0";
                    dwReturn["WGME15KG"] = "0";
                    dwReturn["WGME19"] = "0";
                    dwReturn["WGME19KG"] = "0";
                    dwReturn["WGME20"] = "0";
                    dwReturn["WGME20KG"] = "0";
                    dwReturn["WGME21"] = "0";
                    dwReturn["WGME21KG"] = "0";
                    dwReturn["WGME31"] = "0";
                    dwReturn["WGME31KG"] = "0";
                    dwReturn["WGME32"] = "0";
                    dwReturn["WGME32KG"] = "0";
                    dwReturn["WGME33"] = "0";
                    dwReturn["WGME33KG"] = "0";
                    dwReturn["WGME34"] = "0";
                    dwReturn["WGME34KG"] = "0";
                    dwReturn["WGME35"] = "0";
                    dwReturn["WGME35KG"] = "0";
                    dwReturn["WGME36"] = "0";
                    dwReturn["WGME36KG"] = "0";
                    dwReturn["WGME37"] = "0";
                    dwReturn["WGME37KG"] = "0";
                    dwReturn["WGME40"] = "0";
                    dwReturn["WGME40KG"] = "0";
                    dwReturn["WGME41"] = "0";
                    dwReturn["WGME41KG"] = "0";
                    dwReturn["WGME42"] = "0";
                    dwReturn["WGME42KG"] = "0";
                    dwReturn["WGME43"] = "0";
                    dwReturn["WGME43KG"] = "0";
                    dwReturn["WGME46"] = "0";
                    dwReturn["WGME46KG"] = "0";
                    dwReturn["WGME47"] = "0";
                    dwReturn["WGME47KG"] = "0";
                    dwReturn["WGME48"] = "0";
                    dwReturn["WGME48KG"] = "0";
                    dwReturn["WGME49"] = "0";
                    dwReturn["WGME49KG"] = "0";
                    dwReturn["WGME50"] = "0";
                    dwReturn["WGME50KG"] = "0";
                    dwReturn["WGME51"] = "0";
                    dwReturn["WGME51KG"] = "0";
                    dwReturn["WGME52"] = "0";
                    dwReturn["WGME52KG"] = "0";
                    dwReturn["WGME53"] = "0";
                    dwReturn["WGME53KG"] = "0";
                    dwReturn["WGME55"] = "0";
                    dwReturn["WGME55KG"] = "0";
                    dwReturn["WGME73"] = "0";
                    dwReturn["WGME73KG"] = "0";
                    dwReturn["WGME76"] = "0";
                    dwReturn["WGME76KG"] = "0";
                    dwReturn["WGME79"] = "0";
                    dwReturn["WGME79KG"] = "0";
                    dwReturn["WGME80"] = "0";
                    dwReturn["WGME88"] = "0";
                    dwReturn["WGME89"] = "0";
                    dwReturn["WGME90"] = "0";
                    dwReturn["WGME90KG"] = "0";
                    dwReturn["WGME91"] = "0";
                    dwReturn["WGME91KG"] = "0";
                    dwReturn["WGMER04"] = "0";
                    dwReturn["WGMER05"] = "0";
                    dwReturn["WGRESV1"] = "0";
                    dwReturn["WGRESV2"] = "0";
                    dwReturn["WGRESV3"] = "0";
                    dwReturn["WGRESV4"] = "0";
                    dwReturn["WGRESV5"] = "0";
                    dwReturn["WGBSTA"] = "0";
                    dwReturn["WGBSTAKG"] = "0";
                    dwReturn["WGBSTAN"] = "0";
                    dwReturn["WGBSTANKG"] = "0";
                    dwReturn["WGMEZUTEI"] = "0";
                    dwReturn["WGMEZUTEIKG"] = "0";
                    dwReturn["WGMER02"] = "0";
                    dwReturn["WGMER02KG"] = "0";
                    dwReturn["WGBSTKEN"] = "0";
                    dwReturn["WGBSTKENKG"] = "0";
                    dwReturn["WGBSTKZU"] = "0";
                    dwReturn["WGBSTKZUKG"] = "0";
                    dwReturn["WGBSTKMA"] = "0";
                    dwReturn["WGBSTKMAKG"] = "0";
                    dwReturn["WGBSTKME"] = "0";
                    dwReturn["WGBSTKMEKG"] = "0";
                    dwReturn["WGBSTMA"] = "0";
                    dwReturn["WGBSTMAKG"] = "0";
                    dwReturn["WGBSTME"] = "0";
                    dwReturn["WGBSTMEKG"] = "0";
                    dwReturn["WGBSTVMA"] = "0";
                    dwReturn["WGBSTVMAKG"] = "0";
                    dwReturn["WGBSTVME"] = "0";
                    dwReturn["WGBSTVMEKG"] = "0";
                    dwReturn["WGMEIV"] = "0";
                    dwReturn["WGMEIVKG"] = "0";
                    dwReturn["WGINDAT"] = "0";
                    dwReturn["WGINBST"] = "0";
                    dwReturn["WGINBSTKG"] = "0";
                    dwReturn["WGINALT"] = "0";
                    dwReturn["WGINALTKG"] = "0";
                    dwReturn["WGEKPRMA"] = "0";
                    dwReturn["WGEKPRME"] = "0";
                    dwReturn["WGEKPRZU"] = "0";
                    dwReturn["WGVRPR"] = "0";
                    dwReturn["WGDLABST"] = "0";
                    dwReturn["WGDLABSTKG"] = "0";
                    dwReturn["WGDLATAG"] = "29";
                    dwReturn["WGMINBST"] = "0";
                    dwReturn["WGMINBSTKG"] = "0";
                    dwReturn["WGMAXBST"] = "0";
                    dwReturn["WGMAXBSTKG"] = "0";
                    dwReturn["WGFERTKZ"] = "Z";
                    dwReturn["WGBRT"] = "0";
                    dwReturn["WGGRQM"] = "0";
                    dwReturn["WGGRLFD"] = "0";
                    dwReturn["WGUEBER"] = "N";
                    dwReturn["WGAENDZL"] = "9";
                    dwReturn["WGAENB"] = "        ";
                    dwReturn["WGAEND"] = "0";
                    dwReturn["WGNEUB"] = "        ";
                    dwReturn["WGNEUD"] = "0";
                    dwReturn["WGDART"] = "                    ";
                    dwReturn["WGDVAR"] = "  ";
                    dwReturn["WGFILLER"] = "                                                        ";
                    #endregion
                    break;
                case "JLT":
                    #region=========
                    dwReturn["WGMANDANT"] = app.Mandant;
                    dwReturn["WGSA"] = "00";
                    dwReturn["WGKUNDNR"] = "00000000";
                    dwReturn["WGWERK"] = "   ";
                    dwReturn["WGABT"] = "   ";
                    dwReturn["WGWAKZ"] = "F";
                    dwReturn["WGART"] = "                    ";
                    dwReturn["WGDESS"] = "          ";
                    dwReturn["WGCOLORIT"] = "          ";
                    dwReturn["WGFARBE"] = "          ";
                    dwReturn["WGBESCHICH"] = "          ";
                    dwReturn["WGVAR"] = "  ";
                    dwReturn["WGZUSTAND"] = "    ";
                    dwReturn["WGZENSUR"] = "1";
                    dwReturn["WGZENSURKZ"] = "A";
                    dwReturn["WGLO"] = "01";
                    dwReturn["WGMJJ"] = "2013";
                    dwReturn["WGMM"] = "12";
                    dwReturn["WGAKTKZ"] = " ";
                    dwReturn["WGME01"] = "0";
                    dwReturn["WGME01KG"] = "0";
                    dwReturn["WGME10"] = "0";
                    dwReturn["WGME10KG"] = "0";
                    dwReturn["WGME11"] = "0";
                    dwReturn["WGME11KG"] = "0";
                    dwReturn["WGME12"] = "0";
                    dwReturn["WGME12KG"] = "0";
                    dwReturn["WGME13"] = "0";
                    dwReturn["WGME13KG"] = "0";
                    dwReturn["WGME14"] = "0";
                    dwReturn["WGME14KG"] = "0";
                    dwReturn["WGME15"] = "0";
                    dwReturn["WGME15KG"] = "0";
                    dwReturn["WGME19"] = "0";
                    dwReturn["WGME19KG"] = "0";
                    dwReturn["WGME20"] = "0";
                    dwReturn["WGME20KG"] = "0";
                    dwReturn["WGME21"] = "0";
                    dwReturn["WGME21KG"] = "0";
                    dwReturn["WGME31"] = "0";
                    dwReturn["WGME31KG"] = "0";
                    dwReturn["WGME32"] = "0";
                    dwReturn["WGME32KG"] = "0";
                    dwReturn["WGME33"] = "0";
                    dwReturn["WGME33KG"] = "0";
                    dwReturn["WGME34"] = "0";
                    dwReturn["WGME34KG"] = "0";
                    dwReturn["WGME35"] = "0";
                    dwReturn["WGME35KG"] = "0";
                    dwReturn["WGME36"] = "0";
                    dwReturn["WGME36KG"] = "0";
                    dwReturn["WGME37"] = "0";
                    dwReturn["WGME37KG"] = "0";
                    dwReturn["WGME40"] = "0";
                    dwReturn["WGME40KG"] = "0";
                    dwReturn["WGME41"] = "0";
                    dwReturn["WGME41KG"] = "0";
                    dwReturn["WGME42"] = "0";
                    dwReturn["WGME42KG"] = "3";
                    dwReturn["WGME43"] = "0";
                    dwReturn["WGME43KG"] = "0";
                    dwReturn["WGME46"] = "0";
                    dwReturn["WGME46KG"] = "0";
                    dwReturn["WGME47"] = "0";
                    dwReturn["WGME47KG"] = "0";
                    dwReturn["WGME48"] = "0";
                    dwReturn["WGME48KG"] = "0";
                    dwReturn["WGME49"] = "0";
                    dwReturn["WGME49KG"] = "0";
                    dwReturn["WGME50"] = "0";
                    dwReturn["WGME50KG"] = "0";
                    dwReturn["WGME51"] = "0";
                    dwReturn["WGME51KG"] = "0";
                    dwReturn["WGME52"] = "0";
                    dwReturn["WGME52KG"] = "0";
                    dwReturn["WGME53"] = "0";
                    dwReturn["WGME53KG"] = "0";
                    dwReturn["WGME55"] = "0";
                    dwReturn["WGME55KG"] = "0";
                    dwReturn["WGME73"] = "0";
                    dwReturn["WGME73KG"] = "0";
                    dwReturn["WGME76"] = "0";
                    dwReturn["WGME76KG"] = "0";
                    dwReturn["WGME79"] = "0";
                    dwReturn["WGME79KG"] = "0";
                    dwReturn["WGME80"] = "0";
                    dwReturn["WGME88"] = "0";
                    dwReturn["WGME89"] = "0";
                    dwReturn["WGME90"] = "0";
                    dwReturn["WGME90KG"] = "0";
                    dwReturn["WGME91"] = "0";
                    dwReturn["WGME91KG"] = "0";
                    dwReturn["WGMER04"] = "0";
                    dwReturn["WGMER05"] = "0";
                    dwReturn["WGRESV1"] = "0";
                    dwReturn["WGRESV2"] = "0";
                    dwReturn["WGRESV3"] = "0";
                    dwReturn["WGRESV4"] = "0";
                    dwReturn["WGRESV5"] = "0";
                    dwReturn["WGBSTA"] = "0";
                    dwReturn["WGBSTAKG"] = "0";
                    dwReturn["WGBSTAN"] = "0";
                    dwReturn["WGBSTANKG"] = "0";
                    dwReturn["WGMEZUTEI"] = "0";
                    dwReturn["WGMEZUTEIKG"] = "0";
                    dwReturn["WGMER02"] = "0";
                    dwReturn["WGMER02KG"] = "0";
                    dwReturn["WGBSTKEN"] = "0";
                    dwReturn["WGBSTKENKG"] = "0";
                    dwReturn["WGBSTKZU"] = "0";
                    dwReturn["WGBSTKZUKG"] = "0";
                    dwReturn["WGBSTKMA"] = "0";
                    dwReturn["WGBSTKMAKG"] = "0";
                    dwReturn["WGBSTKME"] = "0";
                    dwReturn["WGBSTKMEKG"] = "0";
                    dwReturn["WGBSTMA"] = "0";
                    dwReturn["WGBSTMAKG"] = "0";
                    dwReturn["WGBSTME"] = "0";
                    dwReturn["WGBSTMEKG"] = "0";
                    dwReturn["WGBSTVMA"] = "0";
                    dwReturn["WGBSTVMAKG"] = "0";
                    dwReturn["WGBSTVME"] = "0";
                    dwReturn["WGBSTVMEKG"] = "0";
                    dwReturn["WGMEIV"] = "0";
                    dwReturn["WGMEIVKG"] = "0";
                    dwReturn["WGINDAT"] = "0";
                    dwReturn["WGINBST"] = "0";
                    dwReturn["WGINBSTKG"] = "0";
                    dwReturn["WGINALT"] = "0";
                    dwReturn["WGINALTKG"] = "0";
                    dwReturn["WGEKPRMA"] = "0";
                    dwReturn["WGEKPRME"] = "0";
                    dwReturn["WGEKPRZU"] = "0";
                    dwReturn["WGVRPR"] = "0";
                    dwReturn["WGDLABST"] = "-0";
                    dwReturn["WGDLABSTKG"] = "0";
                    dwReturn["WGDLATAG"] = "0";
                    dwReturn["WGMINBST"] = "0";
                    dwReturn["WGMINBSTKG"] = "0";
                    dwReturn["WGMAXBST"] = "0";
                    dwReturn["WGMAXBSTKG"] = "0";
                    dwReturn["WGFERTKZ"] = "Z";
                    dwReturn["WGBRT"] = "0";
                    dwReturn["WGGRQM"] = "0";
                    dwReturn["WGGRLFD"] = "0";
                    dwReturn["WGUEBER"] = "N";
                    dwReturn["WGAENDZL"] = "0";
                    dwReturn["WGAENB"] = "        ";
                    dwReturn["WGAEND"] = "0";
                    dwReturn["WGNEUB"] = "     1  ";
                    dwReturn["WGNEUD"] = "0";
                    dwReturn["WGDART"] = "                    ";
                    dwReturn["WGDVAR"] = "  ";
                    dwReturn["WGFILLER"] = "                                                        ";

                    #endregion
                    break;
            }
        }
        public DataRow Convert2WGBST(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryWGBST(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                case "YCC":
                default:
                    #region=========
                    dwReturn["WGMANDANT"] = app.Mandant;
                    dwReturn["WGSA"] = "00";
                    dwReturn["WGKUNDNR"] = "00000000";
                    dwReturn["WGWERK"] = "   ";
                    dwReturn["WGABT"] = "   ";
                    dwReturn["WGWAKZ"] = "F";
                    dwReturn["WGART"] = "TEST5               ";
                    dwReturn["WGDESS"] = "          ";
                    dwReturn["WGCOLORIT"] = "          ";
                    dwReturn["WGFARBE"] = "          ";
                    dwReturn["WGBESCHICH"] = "          ";
                    dwReturn["WGVAR"] = "  ";
                    dwReturn["WGZUSTAND"] = "    ";
                    dwReturn["WGZENSUR"] = "1";
                    dwReturn["WGZENSURKZ"] = "A";
                    dwReturn["WGLO"] = "01";
                    dwReturn["WGMJJ"] = "0";
                    dwReturn["WGMM"] = "  ";
                    dwReturn["WGAKTKZ"] = "A";
                    dwReturn["WGME01"] = "0";
                    dwReturn["WGME01KG"] = "0";
                    dwReturn["WGME10"] = "0";
                    dwReturn["WGME10KG"] = "0";
                    dwReturn["WGME11"] = "0";
                    dwReturn["WGME11KG"] = "0";
                    dwReturn["WGME12"] = "0";
                    dwReturn["WGME12KG"] = "0";
                    dwReturn["WGME13"] = "0";
                    dwReturn["WGME13KG"] = "0";
                    dwReturn["WGME14"] = "0";
                    dwReturn["WGME14KG"] = "0";
                    dwReturn["WGME15"] = "0";
                    dwReturn["WGME15KG"] = "0";
                    dwReturn["WGME19"] = "0";
                    dwReturn["WGME19KG"] = "0";
                    dwReturn["WGME20"] = "0";
                    dwReturn["WGME20KG"] = "0";
                    dwReturn["WGME21"] = "0";
                    dwReturn["WGME21KG"] = "0";
                    dwReturn["WGME31"] = "0";
                    dwReturn["WGME31KG"] = "0";
                    dwReturn["WGME32"] = "0";
                    dwReturn["WGME32KG"] = "0";
                    dwReturn["WGME33"] = "0";
                    dwReturn["WGME33KG"] = "0";
                    dwReturn["WGME34"] = "0";
                    dwReturn["WGME34KG"] = "0";
                    dwReturn["WGME35"] = "0";
                    dwReturn["WGME35KG"] = "0";
                    dwReturn["WGME36"] = "0";
                    dwReturn["WGME36KG"] = "0";
                    dwReturn["WGME37"] = "0";
                    dwReturn["WGME37KG"] = "0";
                    dwReturn["WGME40"] = "0";
                    dwReturn["WGME40KG"] = "0";
                    dwReturn["WGME41"] = "0";
                    dwReturn["WGME41KG"] = "0";
                    dwReturn["WGME42"] = "0";
                    dwReturn["WGME42KG"] = "0";
                    dwReturn["WGME43"] = "0";
                    dwReturn["WGME43KG"] = "0";
                    dwReturn["WGME46"] = "0";
                    dwReturn["WGME46KG"] = "0";
                    dwReturn["WGME47"] = "0";
                    dwReturn["WGME47KG"] = "0";
                    dwReturn["WGME48"] = "0";
                    dwReturn["WGME48KG"] = "0";
                    dwReturn["WGME49"] = "0";
                    dwReturn["WGME49KG"] = "0";
                    dwReturn["WGME50"] = "0";
                    dwReturn["WGME50KG"] = "0";
                    dwReturn["WGME51"] = "0";
                    dwReturn["WGME51KG"] = "0";
                    dwReturn["WGME52"] = "0";
                    dwReturn["WGME52KG"] = "0";
                    dwReturn["WGME53"] = "0";
                    dwReturn["WGME53KG"] = "0";
                    dwReturn["WGME55"] = "0";
                    dwReturn["WGME55KG"] = "0";
                    dwReturn["WGME73"] = "0";
                    dwReturn["WGME73KG"] = "0";
                    dwReturn["WGME76"] = "0";
                    dwReturn["WGME76KG"] = "0";
                    dwReturn["WGME79"] = "0";
                    dwReturn["WGME79KG"] = "0";
                    dwReturn["WGME80"] = "0";
                    dwReturn["WGME88"] = "0";
                    dwReturn["WGME89"] = "0";
                    dwReturn["WGME90"] = "0";
                    dwReturn["WGME90KG"] = "0";
                    dwReturn["WGME91"] = "0";
                    dwReturn["WGME91KG"] = "0";
                    dwReturn["WGMER04"] = "0";
                    dwReturn["WGMER05"] = "0";
                    dwReturn["WGRESV1"] = "0";
                    dwReturn["WGRESV2"] = "0";
                    dwReturn["WGRESV3"] = "0";
                    dwReturn["WGRESV4"] = "0";
                    dwReturn["WGRESV5"] = "0";
                    dwReturn["WGBSTA"] = "0";
                    dwReturn["WGBSTAKG"] = "0";
                    dwReturn["WGBSTAN"] = "0";
                    dwReturn["WGBSTANKG"] = "0";
                    dwReturn["WGMEZUTEI"] = "0";
                    dwReturn["WGMEZUTEIKG"] = "0";
                    dwReturn["WGMER02"] = "0";
                    dwReturn["WGMER02KG"] = "0";
                    dwReturn["WGBSTKEN"] = "0";
                    dwReturn["WGBSTKENKG"] = "0";
                    dwReturn["WGBSTKZU"] = "0";
                    dwReturn["WGBSTKZUKG"] = "0";
                    dwReturn["WGBSTKMA"] = "0";
                    dwReturn["WGBSTKMAKG"] = "0";
                    dwReturn["WGBSTKME"] = "0";
                    dwReturn["WGBSTKMEKG"] = "0";
                    dwReturn["WGBSTMA"] = "0";
                    dwReturn["WGBSTMAKG"] = "0";
                    dwReturn["WGBSTME"] = "0";
                    dwReturn["WGBSTMEKG"] = "0";
                    dwReturn["WGBSTVMA"] = "0";
                    dwReturn["WGBSTVMAKG"] = "0";
                    dwReturn["WGBSTVME"] = "0";
                    dwReturn["WGBSTVMEKG"] = "0";
                    dwReturn["WGMEIV"] = "0";
                    dwReturn["WGMEIVKG"] = "0";
                    dwReturn["WGINDAT"] = "0";
                    dwReturn["WGINBST"] = "0";
                    dwReturn["WGINBSTKG"] = "0";
                    dwReturn["WGINALT"] = "0";
                    dwReturn["WGINALTKG"] = "0";
                    dwReturn["WGEKPRMA"] = "0";
                    dwReturn["WGEKPRME"] = "0";
                    dwReturn["WGEKPRZU"] = "0";
                    dwReturn["WGVRPR"] = "0";
                    dwReturn["WGDLABST"] = "0";
                    dwReturn["WGDLABSTKG"] = "0";
                    dwReturn["WGDLATAG"] = "29";
                    dwReturn["WGMINBST"] = "0";
                    dwReturn["WGMINBSTKG"] = "0";
                    dwReturn["WGMAXBST"] = "0";
                    dwReturn["WGMAXBSTKG"] = "0";
                    dwReturn["WGFERTKZ"] = "Z";
                    dwReturn["WGBRT"] = "0";
                    dwReturn["WGGRQM"] = "0";
                    dwReturn["WGGRLFD"] = "0";
                    dwReturn["WGUEBER"] = "N";
                    dwReturn["WGAENDZL"] = "9";
                    dwReturn["WGAENB"] = "        ";
                    dwReturn["WGAEND"] = "0";
                    dwReturn["WGNEUB"] = "        ";
                    dwReturn["WGNEUD"] = "0";
                    dwReturn["WGDART"] = "                    ";
                    dwReturn["WGDVAR"] = "  ";
                    dwReturn["WGFILLER"] = "                                                        ";
                    #endregion
                    break;
                case "JLT":
                    break;
            }
            INTEXDBC.MapData(IsConvert, ref dwReturn, dwInput);
            return dwReturn;
        }
        public DataSet Convert2WGBST(string ITXDBVERSION)
        {
            DataSet SResult = new DataSet();
            SResult = QueryWGBST(null, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].Rows.Add();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                case "YCC":
                case "SXN":
                case "UBT":
                default:
                    #region=========
                    dwReturn["WGMANDANT"] = app.Mandant;
                    dwReturn["WGSA"] = "00";
                    dwReturn["WGKUNDNR"] = "00000000";
                    dwReturn["WGWERK"] = "   ";
                    dwReturn["WGABT"] = "   ";
                    dwReturn["WGWAKZ"] = "F";
                    dwReturn["WGART"] = "TEST5               ";
                    dwReturn["WGDESS"] = "          ";
                    dwReturn["WGCOLORIT"] = "          ";
                    dwReturn["WGFARBE"] = "          ";
                    dwReturn["WGBESCHICH"] = "          ";
                    dwReturn["WGVAR"] = "  ";
                    dwReturn["WGZUSTAND"] = "    ";
                    dwReturn["WGZENSUR"] = "1";
                    dwReturn["WGZENSURKZ"] = "A";
                    dwReturn["WGLO"] = "01";
                    dwReturn["WGMJJ"] = "0";
                    dwReturn["WGMM"] = "  ";
                    dwReturn["WGAKTKZ"] = "A";
                    dwReturn["WGME01"] = "0";
                    dwReturn["WGME01KG"] = "0";
                    dwReturn["WGME10"] = "0";
                    dwReturn["WGME10KG"] = "0";
                    dwReturn["WGME11"] = "0";
                    dwReturn["WGME11KG"] = "0";
                    dwReturn["WGME12"] = "0";
                    dwReturn["WGME12KG"] = "0";
                    dwReturn["WGME13"] = "0";
                    dwReturn["WGME13KG"] = "0";
                    dwReturn["WGME14"] = "0";
                    dwReturn["WGME14KG"] = "0";
                    dwReturn["WGME15"] = "0";
                    dwReturn["WGME15KG"] = "0";
                    dwReturn["WGME19"] = "0";
                    dwReturn["WGME19KG"] = "0";
                    dwReturn["WGME20"] = "0";
                    dwReturn["WGME20KG"] = "0";
                    dwReturn["WGME21"] = "0";
                    dwReturn["WGME21KG"] = "0";
                    dwReturn["WGME31"] = "0";
                    dwReturn["WGME31KG"] = "0";
                    dwReturn["WGME32"] = "0";
                    dwReturn["WGME32KG"] = "0";
                    dwReturn["WGME33"] = "0";
                    dwReturn["WGME33KG"] = "0";
                    dwReturn["WGME34"] = "0";
                    dwReturn["WGME34KG"] = "0";
                    dwReturn["WGME35"] = "0";
                    dwReturn["WGME35KG"] = "0";
                    dwReturn["WGME36"] = "0";
                    dwReturn["WGME36KG"] = "0";
                    dwReturn["WGME37"] = "0";
                    dwReturn["WGME37KG"] = "0";
                    dwReturn["WGME40"] = "0";
                    dwReturn["WGME40KG"] = "0";
                    dwReturn["WGME41"] = "0";
                    dwReturn["WGME41KG"] = "0";
                    dwReturn["WGME42"] = "0";
                    dwReturn["WGME42KG"] = "0";
                    dwReturn["WGME43"] = "0";
                    dwReturn["WGME43KG"] = "0";
                    dwReturn["WGME46"] = "0";
                    dwReturn["WGME46KG"] = "0";
                    dwReturn["WGME47"] = "0";
                    dwReturn["WGME47KG"] = "0";
                    dwReturn["WGME48"] = "0";
                    dwReturn["WGME48KG"] = "0";
                    dwReturn["WGME49"] = "0";
                    dwReturn["WGME49KG"] = "0";
                    dwReturn["WGME50"] = "0";
                    dwReturn["WGME50KG"] = "0";
                    dwReturn["WGME51"] = "0";
                    dwReturn["WGME51KG"] = "0";
                    dwReturn["WGME52"] = "0";
                    dwReturn["WGME52KG"] = "0";
                    dwReturn["WGME53"] = "0";
                    dwReturn["WGME53KG"] = "0";
                    dwReturn["WGME55"] = "0";
                    dwReturn["WGME55KG"] = "0";
                    dwReturn["WGME73"] = "0";
                    dwReturn["WGME73KG"] = "0";
                    dwReturn["WGME76"] = "0";
                    dwReturn["WGME76KG"] = "0";
                    dwReturn["WGME79"] = "0";
                    dwReturn["WGME79KG"] = "0";
                    dwReturn["WGME80"] = "0";
                    dwReturn["WGME88"] = "0";
                    dwReturn["WGME89"] = "0";
                    dwReturn["WGME90"] = "0";
                    dwReturn["WGME90KG"] = "0";
                    dwReturn["WGME91"] = "0";
                    dwReturn["WGME91KG"] = "0";
                    dwReturn["WGMER04"] = "0";
                    dwReturn["WGMER05"] = "0";
                    dwReturn["WGRESV1"] = "0";
                    dwReturn["WGRESV2"] = "0";
                    dwReturn["WGRESV3"] = "0";
                    dwReturn["WGRESV4"] = "0";
                    dwReturn["WGRESV5"] = "0";
                    dwReturn["WGBSTA"] = "0";
                    dwReturn["WGBSTAKG"] = "0";
                    dwReturn["WGBSTAN"] = "0";
                    dwReturn["WGBSTANKG"] = "0";
                    dwReturn["WGMEZUTEI"] = "0";
                    dwReturn["WGMEZUTEIKG"] = "0";
                    dwReturn["WGMER02"] = "0";
                    dwReturn["WGMER02KG"] = "0";
                    dwReturn["WGBSTKEN"] = "0";
                    dwReturn["WGBSTKENKG"] = "0";
                    dwReturn["WGBSTKZU"] = "0";
                    dwReturn["WGBSTKZUKG"] = "0";
                    dwReturn["WGBSTKMA"] = "0";
                    dwReturn["WGBSTKMAKG"] = "0";
                    dwReturn["WGBSTKME"] = "0";
                    dwReturn["WGBSTKMEKG"] = "0";
                    dwReturn["WGBSTMA"] = "0";
                    dwReturn["WGBSTMAKG"] = "0";
                    dwReturn["WGBSTME"] = "0";
                    dwReturn["WGBSTMEKG"] = "0";
                    dwReturn["WGBSTVMA"] = "0";
                    dwReturn["WGBSTVMAKG"] = "0";
                    dwReturn["WGBSTVME"] = "0";
                    dwReturn["WGBSTVMEKG"] = "0";
                    dwReturn["WGMEIV"] = "0";
                    dwReturn["WGMEIVKG"] = "0";
                    dwReturn["WGINDAT"] = "0";
                    dwReturn["WGINBST"] = "0";
                    dwReturn["WGINBSTKG"] = "0";
                    dwReturn["WGINALT"] = "0";
                    dwReturn["WGINALTKG"] = "0";
                    dwReturn["WGEKPRMA"] = "0";
                    dwReturn["WGEKPRME"] = "0";
                    dwReturn["WGEKPRZU"] = "0";
                    dwReturn["WGVRPR"] = "0";
                    dwReturn["WGDLABST"] = "0";
                    dwReturn["WGDLABSTKG"] = "0";
                    dwReturn["WGDLATAG"] = "29";
                    dwReturn["WGMINBST"] = "0";
                    dwReturn["WGMINBSTKG"] = "0";
                    dwReturn["WGMAXBST"] = "0";
                    dwReturn["WGMAXBSTKG"] = "0";
                    dwReturn["WGFERTKZ"] = "Z";
                    dwReturn["WGBRT"] = "0";
                    dwReturn["WGGRQM"] = "0";
                    dwReturn["WGGRLFD"] = "0";
                    dwReturn["WGUEBER"] = "N";
                    dwReturn["WGAENDZL"] = "9";
                    dwReturn["WGAENB"] = "        ";
                    dwReturn["WGAEND"] = "0";
                    dwReturn["WGNEUB"] = "        ";
                    dwReturn["WGNEUD"] = "0";
                    dwReturn["WGDART"] = "                    ";
                    dwReturn["WGDVAR"] = "  ";
                    dwReturn["WGFILLER"] = "                                                        ";
                    #endregion
                    break;
                case "JLT":
                    break;
            }
            return SResult;
        }
        public void SaveWGBST(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;

            bool flgExist = false;
            setResult = QueryWGBST(dwData, 2);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;

                }
            }

            if (!flgExist)
            {
                InsertWGBST(dwData, ITXDBVERSION);
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                case "YCC":
                case "SXN":
                case "UBT":
                    UpdateWGBST(dwData, ITXDBVERSION, 2);
                    break;
                default:
                    UpdateWGBST(dwData, ITXDBVERSION, 1);
                    break;
            }
        }
        public void InsertWGBST(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                default:
                case "YGR":
                case "YCC":
                case "TST":
                case "SXN":
                case "UBT":
                    or1.CommandText = "INSERT INTO WGBST ( WGMANDANT,WGSA,WGKUNDNR,WGWERK,WGABT,WGWAKZ,WGART,WGDESS,WGCOLORIT,WGFARBE,WGBESCHICH,WGVAR,WGZUSTAND,WGZENSUR,WGZENSURKZ,WGLO,WGMJJ,WGMM,WGAKTKZ,WGME01,WGME01KG,WGME10,WGME10KG,WGME11,WGME11KG,WGME12,WGME12KG,WGME13,WGME13KG,WGME14,WGME14KG,WGME15,WGME15KG,WGME19,WGME19KG,WGME20,WGME20KG,WGME21,WGME21KG,WGME31,WGME31KG,WGME32,WGME32KG,WGME33,WGME33KG,WGME34,WGME34KG,WGME35,WGME35KG,WGME36,WGME36KG,WGME37,WGME37KG,WGME40,WGME40KG,WGME41,WGME41KG,WGME42,WGME42KG,WGME43,WGME43KG,WGME46,WGME46KG,WGME47,WGME47KG,WGME48,WGME48KG,WGME49,WGME49KG,WGME50,WGME50KG,WGME51,WGME51KG,WGME52,WGME52KG,WGME53,WGME53KG,WGME55,WGME55KG,WGME73,WGME73KG,WGME76,WGME76KG,WGME79,WGME79KG,WGME80,WGME88,WGME89,WGME90,WGME90KG,WGME91,WGME91KG,WGMER04,WGMER05,WGRESV1,WGRESV2,WGRESV3,WGRESV4,WGRESV5,WGBSTA,WGBSTAKG,WGBSTAN,WGBSTANKG,WGMEZUTEI,WGMEZUTEIKG,WGMER02,WGMER02KG,WGBSTKEN,WGBSTKENKG,WGBSTKZU,WGBSTKZUKG,WGBSTKMA,WGBSTKMAKG,WGBSTKME,WGBSTKMEKG,WGBSTMA,WGBSTMAKG,WGBSTME,WGBSTMEKG,WGBSTVMA,WGBSTVMAKG,WGBSTVME,WGBSTVMEKG,WGMEIV,WGMEIVKG,WGINDAT,WGINBST,WGINBSTKG,WGINALT,WGINALTKG,WGEKPRMA,WGEKPRME,WGEKPRZU,WGVRPR,WGDLABST,WGDLABSTKG,WGDLATAG,WGMINBST,WGMINBSTKG,WGMAXBST,WGMAXBSTKG,WGFERTKZ,WGBRT,WGGRQM,WGGRLFD,WGUEBER,WGAENDZL,WGAENB,WGAEND,WGNEUB,WGNEUD,WGDART,WGDVAR,WGFILLER)"
                  + " VALUES (:WGMANDANT:,:WGSA:,:WGKUNDNR:,:WGWERK:,:WGABT:,:WGWAKZ:,:WGART:,:WGDESS:,:WGCOLORIT:,:WGFARBE:,:WGBESCHICH:,:WGVAR:,:WGZUSTAND:,:WGZENSUR:,:WGZENSURKZ:,:WGLO:,:WGMJJ:,:WGMM:,:WGAKTKZ:,:WGME01:,:WGME01KG:,:WGME10:,:WGME10KG:,:WGME11:,:WGME11KG:,:WGME12:,:WGME12KG:,:WGME13:,:WGME13KG:,:WGME14:,:WGME14KG:,:WGME15:,:WGME15KG:,:WGME19:,:WGME19KG:,:WGME20:,:WGME20KG:,:WGME21:,:WGME21KG:,:WGME31:,:WGME31KG:,:WGME32:,:WGME32KG:,:WGME33:,:WGME33KG:,:WGME34:,:WGME34KG:,:WGME35:,:WGME35KG:,:WGME36:,:WGME36KG:,:WGME37:,:WGME37KG:,:WGME40:,:WGME40KG:,:WGME41:,:WGME41KG:,:WGME42:,:WGME42KG:,:WGME43:,:WGME43KG:,:WGME46:,:WGME46KG:,:WGME47:,:WGME47KG:,:WGME48:,:WGME48KG:,:WGME49:,:WGME49KG:,:WGME50:,:WGME50KG:,:WGME51:,:WGME51KG:,:WGME52:,:WGME52KG:,:WGME53:,:WGME53KG:,:WGME55:,:WGME55KG:,:WGME73:,:WGME73KG:,:WGME76:,:WGME76KG:,:WGME79:,:WGME79KG:,:WGME80:,:WGME88:,:WGME89:,:WGME90:,:WGME90KG:,:WGME91:,:WGME91KG:,:WGMER04:,:WGMER05:,:WGRESV1:,:WGRESV2:,:WGRESV3:,:WGRESV4:,:WGRESV5:,:WGBSTA:,:WGBSTAKG:,:WGBSTAN:,:WGBSTANKG:,:WGMEZUTEI:,:WGMEZUTEIKG:,:WGMER02:,:WGMER02KG:,:WGBSTKEN:,:WGBSTKENKG:,:WGBSTKZU:,:WGBSTKZUKG:,:WGBSTKMA:,:WGBSTKMAKG:,:WGBSTKME:,:WGBSTKMEKG:,:WGBSTMA:,:WGBSTMAKG:,:WGBSTME:,:WGBSTMEKG:,:WGBSTVMA:,:WGBSTVMAKG:,:WGBSTVME:,:WGBSTVMEKG:,:WGMEIV:,:WGMEIVKG:,:WGINDAT:,:WGINBST:,:WGINBSTKG:,:WGINALT:,:WGINALTKG:,:WGEKPRMA:,:WGEKPRME:,:WGEKPRZU:,:WGVRPR:,:WGDLABST:,:WGDLABSTKG:,:WGDLATAG:,:WGMINBST:,:WGMINBSTKG:,:WGMAXBST:,:WGMAXBSTKG:,:WGFERTKZ:,:WGBRT:,:WGGRQM:,:WGGRLFD:,:WGUEBER:,:WGAENDZL:,:WGAENB:,:WGAEND:,:WGNEUB:,:WGNEUD:,:WGDART:,:WGDVAR:,:WGFILLER:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case "JLT":
                    or1.CommandText = "INSERT INTO WGBST ( WGMANDANT,WGSA,WGKUNDNR,WGWERK,WGABT,WGWAKZ,WGART,WGDESS,WGCOLORIT,WGFARBE,WGBESCHICH,WGVAR,WGZUSTAND,WGZENSUR,WGZENSURKZ,WGLO,WGMJJ,WGMM,WGAKTKZ,WGME01,WGME01KG,WGME10,WGME10KG,WGME11,WGME11KG,WGME12,WGME12KG,WGME13,WGME13KG,WGME14,WGME14KG,WGME15,WGME15KG,WGME19,WGME19KG,WGME20,WGME20KG,WGME21,WGME21KG,WGME31,WGME31KG,WGME32,WGME32KG,WGME33,WGME33KG,WGME34,WGME34KG,WGME35,WGME35KG,WGME36,WGME36KG,WGME37,WGME37KG,WGME40,WGME40KG,WGME41,WGME41KG,WGME42,WGME42KG,WGME43,WGME43KG,WGME46,WGME46KG,WGME47,WGME47KG,WGME48,WGME48KG,WGME49,WGME49KG,WGME50,WGME50KG,WGME51,WGME51KG,WGME52,WGME52KG,WGME53,WGME53KG,WGME55,WGME55KG,WGME73,WGME73KG,WGME76,WGME76KG,WGME79,WGME79KG,WGME80,WGME88,WGME89,WGME90,WGME90KG,WGME91,WGME91KG,WGMER04,WGMER05,WGRESV1,WGRESV2,WGRESV3,WGRESV4,WGRESV5,WGBSTA,WGBSTAKG,WGBSTAN,WGBSTANKG,WGMEZUTEI,WGMEZUTEIKG,WGMER02,WGMER02KG,WGBSTKEN,WGBSTKENKG,WGBSTKZU,WGBSTKZUKG,WGBSTKMA,WGBSTKMAKG,WGBSTKME,WGBSTKMEKG,WGBSTMA,WGBSTMAKG,WGBSTME,WGBSTMEKG,WGBSTVMA,WGBSTVMAKG,WGBSTVME,WGBSTVMEKG,WGMEIV,WGMEIVKG,WGINDAT,WGINBST,WGINBSTKG,WGINALT,WGINALTKG,WGEKPRMA,WGEKPRME,WGEKPRZU,WGVRPR,WGDLABST,WGDLABSTKG,WGDLATAG,WGMINBST,WGMINBSTKG,WGMAXBST,WGMAXBSTKG,WGFERTKZ,WGBRT,WGGRQM,WGGRLFD,WGUEBER,WGAENDZL,WGAENB,WGAEND,WGNEUB,WGNEUD,WGDART,WGDVAR,WGFILLER)"
                    + " VALUES (:WGMANDANT:,:WGSA:,:WGKUNDNR:,:WGWERK:,:WGABT:,:WGWAKZ:,:WGART:,:WGDESS:,:WGCOLORIT:,:WGFARBE:,:WGBESCHICH:,:WGVAR:,:WGZUSTAND:,:WGZENSUR:,:WGZENSURKZ:,:WGLO:,:WGMJJ:,:WGMM:,:WGAKTKZ:,:WGME01:,:WGME01KG:,:WGME10:,:WGME10KG:,:WGME11:,:WGME11KG:,:WGME12:,:WGME12KG:,:WGME13:,:WGME13KG:,:WGME14:,:WGME14KG:,:WGME15:,:WGME15KG:,:WGME19:,:WGME19KG:,:WGME20:,:WGME20KG:,:WGME21:,:WGME21KG:,:WGME31:,:WGME31KG:,:WGME32:,:WGME32KG:,:WGME33:,:WGME33KG:,:WGME34:,:WGME34KG:,:WGME35:,:WGME35KG:,:WGME36:,:WGME36KG:,:WGME37:,:WGME37KG:,:WGME40:,:WGME40KG:,:WGME41:,:WGME41KG:,:WGME42:,:WGME42KG:,:WGME43:,:WGME43KG:,:WGME46:,:WGME46KG:,:WGME47:,:WGME47KG:,:WGME48:,:WGME48KG:,:WGME49:,:WGME49KG:,:WGME50:,:WGME50KG:,:WGME51:,:WGME51KG:,:WGME52:,:WGME52KG:,:WGME53:,:WGME53KG:,:WGME55:,:WGME55KG:,:WGME73:,:WGME73KG:,:WGME76:,:WGME76KG:,:WGME79:,:WGME79KG:,:WGME80:,:WGME88:,:WGME89:,:WGME90:,:WGME90KG:,:WGME91:,:WGME91KG:,:WGMER04:,:WGMER05:,:WGRESV1:,:WGRESV2:,:WGRESV3:,:WGRESV4:,:WGRESV5:,:WGBSTA:,:WGBSTAKG:,:WGBSTAN:,:WGBSTANKG:,:WGMEZUTEI:,:WGMEZUTEIKG:,:WGMER02:,:WGMER02KG:,:WGBSTKEN:,:WGBSTKENKG:,:WGBSTKZU:,:WGBSTKZUKG:,:WGBSTKMA:,:WGBSTKMAKG:,:WGBSTKME:,:WGBSTKMEKG:,:WGBSTMA:,:WGBSTMAKG:,:WGBSTME:,:WGBSTMEKG:,:WGBSTVMA:,:WGBSTVMAKG:,:WGBSTVME:,:WGBSTVMEKG:,:WGMEIV:,:WGMEIVKG:,:WGINDAT:,:WGINBST:,:WGINBSTKG:,:WGINALT:,:WGINALTKG:,:WGEKPRMA:,:WGEKPRME:,:WGEKPRZU:,:WGVRPR:,:WGDLABST:,:WGDLABSTKG:,:WGDLATAG:,:WGMINBST:,:WGMINBSTKG:,:WGMAXBST:,:WGMAXBSTKG:,:WGFERTKZ:,:WGBRT:,:WGGRQM:,:WGGRLFD:,:WGUEBER:,:WGAENDZL:,:WGAENB:,:WGAEND:,:WGNEUB:,:WGNEUD:,:WGDART:,:WGDVAR:,:WGFILLER:)";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case "YCA":
                    or1.CommandText = "INSERT INTO WGBST(WGMANDANT, WGSA, WGKUNDNR, WGWERK, WGABT, WGWAKZ, WGART, WGDESS, WGCOLORIT, WGFARBE, WGBESCHICH, WGVAR, WGZUSTAND, WGZENSUR, WGZENSURKZ, WGLO, WGMJJ, WGMM, WGAKTKZ, WGME01, WGME01KG, WGME10, WGME10KG, WGME11, WGME11KG, WGME12, WGME12KG, WGME13, WGME13KG, WGME14, WGME14KG, WGME15, WGME15KG, WGME19, WGME19KG, WGME20, WGME20KG, WGME21, WGME21KG, WGME31, WGME31KG, WGME32, WGME32KG, WGME33, WGME33KG, WGME34, WGME34KG, WGME35, WGME35KG, WGME36, WGME36KG, WGME37, WGME37KG, WGME40, WGME40KG, WGME41, WGME41KG, WGME42, WGME42KG, WGME43, WGME43KG, WGME46, WGME46KG, WGME47, WGME47KG, WGME48, WGME48KG, WGME49, WGME49KG, WGME50, WGME50KG, WGME51, WGME51KG, WGME52, WGME52KG, WGME53, WGME53KG, WGME55, WGME55KG, WGME73, WGME73KG, WGME76, WGME76KG, WGME79, WGME79KG, WGME80, WGME88, WGME89, WGME90, WGME90KG, WGME91, WGME91KG, WGMER04, WGMER05, WGRESV1, WGRESV2, WGRESV3, WGRESV4, WGRESV5, WGBSTA, WGBSTAKG, WGBSTAN, WGBSTANKG, WGMEZUTEI, WGMEZUTEIKG, WGMER02, WGMER02KG, WGBSTKEN, WGBSTKENKG, WGBSTKZU, WGBSTKZUKG, WGBSTKMA, WGBSTKMAKG, WGBSTKME, WGBSTKMEKG, WGBSTMA, WGBSTMAKG, WGBSTME, WGBSTMEKG, WGBSTVMA, WGBSTVMAKG, WGBSTVME, WGBSTVMEKG, WGMEIV, WGMEIVKG, WGINDAT, WGINBST, WGINBSTKG, WGINALT, WGINALTKG, WGEKPRMA, WGEKPRME, WGEKPRZU, WGVRPR, WGDLABST, WGDLABSTKG, WGDLATAG, WGMINBST, WGMINBSTKG, WGMAXBST, WGMAXBSTKG, WGFERTKZ, WGBRT, WGGRQM, WGGRLFD, WGUEBER, WGAENDZL, WGAENB, WGAEND, WGNEUB, WGNEUD,WGFILLER)"
              + " VALUES (:WGMANDANT:, :WGSA:, :WGKUNDNR:, :WGWERK:, :WGABT:,:WGWAKZ:, :WGART:,:WGDESS:, :WGCOLORIT:, :WGFARBE,:WGBESCHICH:, :WGVAR:, :WGZUSTAND:,:WGZENSUR:, :WGZENSURKZ:, :WGLO:,:WGMJJ:, :WGMM:, 'A', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2300, 605, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2300, 605, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 460, 121, '07', 0, 0, 2300, 605, 'F', 14200, 185, 263, 'N', 0, '        ', 0, 'ZMF     ', 20120907, '                                                        ')";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData); 
                    break;
            }

            // WGMANDANT, WGSA, WGKUNDNR, WGWERK, WGABT, WGWAKZ, WGART, WGDESS, WGCOLORIT, WGFARBE, WGBESCHICH, WGVAR
            //, WGZUSTAND, WGZENSUR, WGZENSURKZ, WGLO, WGMJJ, WGMM
            Connect2Proxy(or1);
        }
        public DataSet QueryWGBST(DataRow dwData, int option)
        { 
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM WGBST WHERE  ROWNUM<2 ";
                    SResult = Connect2Proxy(or1);
                    break;
                case 1:
                    or1.CommandText = "SELECT * FROM WGBST WHERE "
                  + "  WGMANDANT=:WGMANDANT: AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:"
                  + "  AND WGFARBE=:WGFARBE: AND WGBESCHICH=:WGBESCHICH: AND WGDESS=:WGDESS: AND WGCOLORIT=:WGCOLORIT:"
                  + " AND WGLO=:WGLO:"
                  + " ORDER BY WGMJJ DESC,WGMM DESC ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);
                    break;
                case 2: SResult = QWG02(dwData); break;
                case 3:
                    or1.CommandText = "SELECT * FROM WGBST WHERE   WGMANDANT=:WGMANDANT: AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:  AND WGFARBE=:WGFARBE:  AND WGLO=:WGLO: AND WGMJJ=:WGMJJ: AND WGMM=:WGMM:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);
                    break;
                case 4:
                    or1.CommandText = "SELECT * FROM WGBST WHERE WGMANDANT=:WGMANDANT:"
                  + " AND  WGMJJ LIKE '" + dwData["WGMJJ"].ToString().Trim() + "%'"
                  + " AND  WGMM LIKE '" + dwData["WGMM"].ToString().Trim() + "%'"
                  + " AND  WGLO LIKE '" + dwData["WGLO"].ToString().Trim() + "%'"
                   + " AND  WGART LIKE '" + dwData["WGART"].ToString().Trim() + "%'"
                   + " AND  WGVAR LIKE '" + dwData["WGVAR"].ToString().Trim() + "%'"
                  + " AND  WGFARBE LIKE '" + dwData["WGFARBE"].ToString().Trim() + "%'"
                  + " ORDER BY WGMJJ DESC,WGMM DESC ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    SResult = Connect2Proxy(or1);
                    break;
                case 5:SResult = QWG05(dwData);  break;

            }
          
            SResult.Tables[0].TableName = TableName;

            return SResult;
        }
        public DataSet QWG02(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM WGBST WHERE "
                 + "  WGMANDANT=:WGMANDANT: AND WGSA=:WGSA: AND WGKUNDNR=:WGKUNDNR: AND WGWERK=:WGWERK: AND WGABT=:WGABT: AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:"
                 + "  AND WGFARBE=:WGFARBE: AND WGBESCHICH=:WGBESCHICH: AND WGDESS=:WGDESS: AND WGCOLORIT=:WGCOLORIT:"
                 + "  AND WGZUSTAND=:WGZUSTAND: AND WGZENSUR=:WGZENSUR: AND WGZENSURKZ=:WGZENSURKZ: AND WGLO=:WGLO: AND WGMJJ=:WGMJJ: AND WGMM=:WGMM:"
                 + " ORDER BY WGMJJ DESC,WGMM DESC ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName;
            return SResult;
        }
        public DataSet QWG05(DataRow dwData)
        {
            or1 = OracleDB.CreateCommand();
            or1.CommandText = "SELECT * FROM WGBST"
                + " WHERE  WGMANDANT=:WGMANDANT: AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:  AND WGFARBE=:WGFARBE:  AND WGBESCHICH=:WGBESCHICH: AND WGDESS=:WGDESS: AND WGCOLORIT=:WGCOLORIT: AND WGLO=:WGLO: AND WGMJJ=:WGMJJ: "
                    + " ORDER BY WGMM DESC";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
            SResult = Connect2Proxy(or1);
            SResult.Tables[0].TableName = TableName; 
            return SResult;
        }
        public void DeleteWGBST(DataRow dwData, int option = 1)
        {

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM WGBST "
                         + " WHERE WGMANDANT=:WGMANDANT: AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:  AND WGFARBE=:WGFARBE:  AND WGLO=:WGLO: AND WGMJJ=:WGMJJ: AND WGMM=:WGMM:";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        }
        public void DWG00(DataRow dwData)
        {

            or1 = OracleDB.CreateCommand(); 
            or1.CommandText = "DELETE FROM WGBST WHERE WGMANDANT=:WGMANDANT: ";
            or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);

            Connect2Proxy(or1);
        }
        public void UpdateWGBST(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            if (option == 0)
            {
                switch (app.company)
                {
                    case "YGR":
                    case "TST":
                    case "SXN":
                    case "UBT":
                        option = 2;
                        break;
                    case "JLT":
                        option = 3;
                        break;
                    default:
                        option = 1;
                        break;
                }
            }
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE WGBST SET "
                        + "WGMANDANT=:WGMANDANT:,"
                        + "WGSA=:WGSA:,"
                        + "WGKUNDNR=:WGKUNDNR:,"
                        + "WGWERK=:WGWERK:,"
                        + "WGABT=:WGABT:,"
                        + "WGWAKZ=:WGWAKZ:,"
                        + "WGART=:WGART:,"
                        + "WGDESS=:WGDESS:,"
                        + "WGCOLORIT=:WGCOLORIT:,"
                        + "WGFARBE=:WGFARBE:,"
                        + "WGBESCHICH=:WGBESCHICH:,"
                        + "WGVAR=:WGVAR:,"
                        + "WGZUSTAND=:WGZUSTAND:,"
                        + "WGZENSUR=:WGZENSUR:,"
                        + "WGZENSURKZ=:WGZENSURKZ:,"
                        + "WGLO=:WGLO:,"
                        + "WGMJJ=:WGMJJ:,"
                        + "WGMM=:WGMM:,"
                        + "WGAKTKZ=:WGAKTKZ:,"
                        + "WGME01=:WGME01:,"
                        + "WGME01KG=:WGME01KG:,"
                        + "WGME10=:WGME10:,"
                        + "WGME10KG=:WGME10KG:,"
                        + "WGME11=:WGME11:,"
                        + "WGME11KG=:WGME11KG:,"
                        + "WGME12=:WGME12:,"
                        + "WGME12KG=:WGME12KG:,"
                        + "WGME13=:WGME13:,"
                        + "WGME13KG=:WGME13KG:,"
                        + "WGME14=:WGME14:,"
                        + "WGME14KG=:WGME14KG:,"
                        + "WGME15=:WGME15:,"
                        + "WGME15KG=:WGME15KG:,"
                        + "WGME19=:WGME19:,"
                        + "WGME19KG=:WGME19KG:,"
                        + "WGME20=:WGME20:,"
                        + "WGME20KG=:WGME20KG:,"
                        + "WGME21=:WGME21:,"
                        + "WGME21KG=:WGME21KG:,"
                        + "WGME31=:WGME31:,"
                        + "WGME31KG=:WGME31KG:,"
                        + "WGME32=:WGME32:,"
                        + "WGME32KG=:WGME32KG:,"
                        + "WGME33=:WGME33:,"
                        + "WGME33KG=:WGME33KG:,"
                        + "WGME34=:WGME34:,"
                        + "WGME34KG=:WGME34KG:,"
                        + "WGME35=:WGME35:,"
                        + "WGME35KG=:WGME35KG:,"
                        + "WGME36=:WGME36:,"
                        + "WGME36KG=:WGME36KG:,"
                        + "WGME37=:WGME37:,"
                        + "WGME37KG=:WGME37KG:,"
                        + "WGME40=:WGME40:,"
                        + "WGME40KG=:WGME40KG:,"
                        + "WGME41=:WGME41:,"
                        + "WGME41KG=:WGME41KG:,"
                        + "WGME42=:WGME42:,"
                        + "WGME42KG=:WGME42KG:,"
                        + "WGME43=:WGME43:,"
                        + "WGME43KG=:WGME43KG:,"
                        + "WGME46=:WGME46:,"
                        + "WGME46KG=:WGME46KG:,"
                        + "WGME47=:WGME47:,"
                        + "WGME47KG=:WGME47KG:,"
                        + "WGME48=:WGME48:,"
                        + "WGME48KG=:WGME48KG:,"
                        + "WGME49=:WGME49:,"
                        + "WGME49KG=:WGME49KG:,"
                        + "WGME50=:WGME50:,"
                        + "WGME50KG=:WGME50KG:,"
                        + "WGME51=:WGME51:,"
                        + "WGME51KG=:WGME51KG:,"
                        + "WGME52=:WGME52:,"
                        + "WGME52KG=:WGME52KG:,"
                        + "WGME53=:WGME53:,"
                        + "WGME53KG=:WGME53KG:,"
                        + "WGME55=:WGME55:,"
                        + "WGME55KG=:WGME55KG:,"
                        + "WGME73=:WGME73:,"
                        + "WGME73KG=:WGME73KG:,"
                        + "WGME76=:WGME76:,"
                        + "WGME76KG=:WGME76KG:,"
                        + "WGME79=:WGME79:,"
                        + "WGME79KG=:WGME79KG:,"
                        + "WGME80=:WGME80:,"
                        + "WGME88=:WGME88:,"
                        + "WGME89=:WGME89:,"
                        + "WGME90=:WGME90:,"
                        + "WGME90KG=:WGME90KG:,"
                        + "WGME91=:WGME91:,"
                        + "WGME91KG=:WGME91KG:,"
                        + "WGMER04=:WGMER04:,"
                        + "WGMER05=:WGMER05:,"
                        + "WGRESV1=:WGRESV1:,"
                        + "WGRESV2=:WGRESV2:,"
                        + "WGRESV3=:WGRESV3:,"
                        + "WGRESV4=:WGRESV4:,"
                        + "WGRESV5=:WGRESV5:,"
                        + "WGBSTA=:WGBSTA:,"
                        + "WGBSTAKG=:WGBSTAKG:,"
                        + "WGBSTAN=:WGBSTAN:,"
                        + "WGBSTANKG=:WGBSTANKG:,"
                        + "WGMEZUTEI=:WGMEZUTEI:,"
                        + "WGMEZUTEIKG=:WGMEZUTEIKG:,"
                        + "WGMER02=:WGMER02:,"
                        + "WGMER02KG=:WGMER02KG:,"
                        + "WGBSTKEN=:WGBSTKEN:,"
                        + "WGBSTKENKG=:WGBSTKENKG:,"
                        + "WGBSTKZU=:WGBSTKZU:,"
                        + "WGBSTKZUKG=:WGBSTKZUKG:,"
                        + "WGBSTKMA=:WGBSTKMA:,"
                        + "WGBSTKMAKG=:WGBSTKMAKG:,"
                        + "WGBSTKME=:WGBSTKME:,"
                        + "WGBSTKMEKG=:WGBSTKMEKG:,"
                        + "WGBSTMA=:WGBSTMA:,"
                        + "WGBSTMAKG=:WGBSTMAKG:,"
                        + "WGBSTME=:WGBSTME:,"
                        + "WGBSTMEKG=:WGBSTMEKG:,"
                        + "WGBSTVMA=:WGBSTVMA:,"
                        + "WGBSTVMAKG=:WGBSTVMAKG:,"
                        + "WGBSTVME=:WGBSTVME:,"
                        + "WGBSTVMEKG=:WGBSTVMEKG:,"
                        + "WGMEIV=:WGMEIV:,"
                        + "WGMEIVKG=:WGMEIVKG:,"
                        + "WGINDAT=:WGINDAT:,"
                        + "WGINBST=:WGINBST:,"
                        + "WGINBSTKG=:WGINBSTKG:,"
                        + "WGINALT=:WGINALT:,"
                        + "WGINALTKG=:WGINALTKG:,"
                        + "WGEKPRMA=:WGEKPRMA:,"
                        + "WGEKPRME=:WGEKPRME:,"
                        + "WGEKPRZU=:WGEKPRZU:,"
                        + "WGVRPR=:WGVRPR:,"
                        + "WGDLABST=:WGDLABST:,"
                        + "WGDLABSTKG=:WGDLABSTKG:,"
                        + "WGDLATAG=:WGDLATAG:,"
                        + "WGMINBST=:WGMINBST:,"
                        + "WGMINBSTKG=:WGMINBSTKG:,"
                        + "WGMAXBST=:WGMAXBST:,"
                        + "WGMAXBSTKG=:WGMAXBSTKG:,"
                        + "WGFERTKZ=:WGFERTKZ:,"
                        + "WGBRT=:WGBRT:,"
                        + "WGGRQM=:WGGRQM:,"
                        + "WGGRLFD=:WGGRLFD:,"
                        + "WGUEBER=:WGUEBER:,"
                        + "WGAENDZL=:WGAENDZL:,"
                        + "WGAENB=:WGAENB:,"
                        + "WGAEND=:WGAEND:,"
                        + "WGNEUB=:WGNEUB:,"
                        + "WGNEUD=:WGNEUD:,"
                        + "WGFILLER=:WGFILLER:"
                        + " WHERE  "
                               + "  WGMANDANT=:WGMANDANT: AND WGSA=:WGSA: AND WGKUNDNR=:WGKUNDNR: AND WGWERK=:WGWERK:"
                               + "  AND WGABT=:WGABT AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:"
                               + "  AND WGFARBE=:WGFARBE: AND WGBESCHICH=:WGBESCHICH: AND WGDESS=:WGDESS: AND WGCOLORIT=:WGCOLORIT:"
                            + "  AND WGZUSTAND=:WGZUSTAND: AND WGZENSUR=:WGZENSUR: AND WGZENSURKZ=:WGZENSURKZ: AND WGLO=:WGLO:"
                            + " AND WGMJJ=:WGMJJ: AND WGMM=:WGMM: ";
                    #endregion
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 2:
                    #region====Command====
                    or1.CommandText = "UPDATE WGBST SET WGMANDANT=:WGMANDANT:,WGSA=:WGSA:,WGKUNDNR=:WGKUNDNR:,WGWERK=:WGWERK:,WGABT=:WGABT:,WGWAKZ=:WGWAKZ:,WGART=:WGART:,WGDESS=:WGDESS:,WGCOLORIT=:WGCOLORIT:,WGFARBE=:WGFARBE:,WGBESCHICH=:WGBESCHICH:,WGVAR=:WGVAR:,WGZUSTAND=:WGZUSTAND:,WGZENSUR=:WGZENSUR:,WGZENSURKZ=:WGZENSURKZ:,WGLO=:WGLO:,WGMJJ=:WGMJJ:,WGMM=:WGMM:,WGAKTKZ=:WGAKTKZ:,WGME01=:WGME01:,WGME01KG=:WGME01KG:,WGME10=:WGME10:,WGME10KG=:WGME10KG:,WGME11=:WGME11:,WGME11KG=:WGME11KG:,WGME12=:WGME12:,WGME12KG=:WGME12KG:,WGME13=:WGME13:,WGME13KG=:WGME13KG:,WGME14=:WGME14:,WGME14KG=:WGME14KG:,WGME15=:WGME15:,WGME15KG=:WGME15KG:,WGME19=:WGME19:,WGME19KG=:WGME19KG:,WGME20=:WGME20:,WGME20KG=:WGME20KG:,WGME21=:WGME21:,WGME21KG=:WGME21KG:,WGME31=:WGME31:,WGME31KG=:WGME31KG:,WGME32=:WGME32:,WGME32KG=:WGME32KG:,WGME33=:WGME33:,WGME33KG=:WGME33KG:,WGME34=:WGME34:,WGME34KG=:WGME34KG:,WGME35=:WGME35:,WGME35KG=:WGME35KG:,WGME36=:WGME36:,WGME36KG=:WGME36KG:,WGME37=:WGME37:,WGME37KG=:WGME37KG:,WGME40=:WGME40:,WGME40KG=:WGME40KG:,WGME41=:WGME41:,WGME41KG=:WGME41KG:,WGME42=:WGME42:,WGME42KG=:WGME42KG:,WGME43=:WGME43:,WGME43KG=:WGME43KG:,WGME46=:WGME46:,WGME46KG=:WGME46KG:,WGME47=:WGME47:,WGME47KG=:WGME47KG:,WGME48=:WGME48:,WGME48KG=:WGME48KG:,WGME49=:WGME49:,WGME49KG=:WGME49KG:,WGME50=:WGME50:,WGME50KG=:WGME50KG:,WGME51=:WGME51:,WGME51KG=:WGME51KG:,WGME52=:WGME52:,WGME52KG=:WGME52KG:,WGME53=:WGME53:,WGME53KG=:WGME53KG:,WGME55=:WGME55:,WGME55KG=:WGME55KG:,WGME73=:WGME73:,WGME73KG=:WGME73KG:,WGME76=:WGME76:,WGME76KG=:WGME76KG:,WGME79=:WGME79:,WGME79KG=:WGME79KG:,WGME80=:WGME80:,WGME88=:WGME88:,WGME89=:WGME89:,WGME90=:WGME90:,WGME90KG=:WGME90KG:,WGME91=:WGME91:,WGME91KG=:WGME91KG:,WGMER04=:WGMER04:,WGMER05=:WGMER05:,WGRESV1=:WGRESV1:,WGRESV2=:WGRESV2:,WGRESV3=:WGRESV3:,WGRESV4=:WGRESV4:,WGRESV5=:WGRESV5:,WGBSTA=:WGBSTA:,WGBSTAKG=:WGBSTAKG:,WGBSTAN=:WGBSTAN:,WGBSTANKG=:WGBSTANKG:,WGMEZUTEI=:WGMEZUTEI:,WGMEZUTEIKG=:WGMEZUTEIKG:,WGMER02=:WGMER02:,WGMER02KG=:WGMER02KG:,WGBSTKEN=:WGBSTKEN:,WGBSTKENKG=:WGBSTKENKG:,WGBSTKZU=:WGBSTKZU:,WGBSTKZUKG=:WGBSTKZUKG:,WGBSTKMA=:WGBSTKMA:,WGBSTKMAKG=:WGBSTKMAKG:,WGBSTKME=:WGBSTKME:,WGBSTKMEKG=:WGBSTKMEKG:,WGBSTMA=:WGBSTMA:,WGBSTMAKG=:WGBSTMAKG:,WGBSTME=:WGBSTME:,WGBSTMEKG=:WGBSTMEKG:,WGBSTVMA=:WGBSTVMA:,WGBSTVMAKG=:WGBSTVMAKG:,WGBSTVME=:WGBSTVME:,WGBSTVMEKG=:WGBSTVMEKG:,WGMEIV=:WGMEIV:,WGMEIVKG=:WGMEIVKG:,WGINDAT=:WGINDAT:,WGINBST=:WGINBST:,WGINBSTKG=:WGINBSTKG:,WGINALT=:WGINALT:,WGINALTKG=:WGINALTKG:,WGEKPRMA=:WGEKPRMA:,WGEKPRME=:WGEKPRME:,WGEKPRZU=:WGEKPRZU:,WGVRPR=:WGVRPR:,WGDLABST=:WGDLABST:,WGDLABSTKG=:WGDLABSTKG:,WGDLATAG=:WGDLATAG:,WGMINBST=:WGMINBST:,WGMINBSTKG=:WGMINBSTKG:,WGMAXBST=:WGMAXBST:,WGMAXBSTKG=:WGMAXBSTKG:,WGFERTKZ=:WGFERTKZ:,WGBRT=:WGBRT:,WGGRQM=:WGGRQM:,WGGRLFD=:WGGRLFD:,WGUEBER=:WGUEBER:,WGAENDZL=:WGAENDZL:,WGAENB=:WGAENB:,WGAEND=:WGAEND:, WGDART=:WGDART:,WGDVAR=:WGDVAR:,WGFILLER=:WGFILLER: "
                        + " WHERE    WGMANDANT=:WGMANDANT: AND WGSA=:WGSA: AND WGKUNDNR=:WGKUNDNR: AND WGWERK=:WGWERK: AND WGABT=:WGABT: AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:"
                       + "  AND WGFARBE=:WGFARBE: AND WGBESCHICH=:WGBESCHICH: AND WGDESS=:WGDESS: AND WGCOLORIT=:WGCOLORIT:   AND WGZUSTAND=:WGZUSTAND: AND WGZENSUR=:WGZENSUR: AND WGZENSURKZ=:WGZENSURKZ: AND WGLO=:WGLO:"
                    + " AND WGMJJ=:WGMJJ: AND WGMM=:WGMM: ";
                    #endregion
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
                case 3:
                    or1.CommandText = "UPDATE WGBST SET WGMANDANT=:WGMANDANT:,WGSA=:WGSA:,WGKUNDNR=:WGKUNDNR:,WGWERK=:WGWERK:,WGABT=:WGABT:,WGWAKZ=:WGWAKZ:,WGART=:WGART:,WGDESS=:WGDESS:,WGCOLORIT=:WGCOLORIT:,WGFARBE=:WGFARBE:,WGBESCHICH=:WGBESCHICH:,WGVAR=:WGVAR:,WGZUSTAND=:WGZUSTAND:,WGZENSUR=:WGZENSUR:,WGZENSURKZ=:WGZENSURKZ:,WGLO=:WGLO:,WGMJJ=:WGMJJ:,WGMM=:WGMM:,WGAKTKZ=:WGAKTKZ:,WGME01=:WGME01:,WGME01KG=:WGME01KG:,WGME10=:WGME10:,WGME10KG=:WGME10KG:,WGME11=:WGME11:,WGME11KG=:WGME11KG:,WGME12=:WGME12:,WGME12KG=:WGME12KG:,WGME13=:WGME13:,WGME13KG=:WGME13KG:,WGME14=:WGME14:,WGME14KG=:WGME14KG:,WGME15=:WGME15:,WGME15KG=:WGME15KG:,WGME19=:WGME19:,WGME19KG=:WGME19KG:,WGME20=:WGME20:,WGME20KG=:WGME20KG:,WGME21=:WGME21:,WGME21KG=:WGME21KG:,WGME31=:WGME31:,WGME31KG=:WGME31KG:,WGME32=:WGME32:,WGME32KG=:WGME32KG:,WGME33=:WGME33:,WGME33KG=:WGME33KG:,WGME34=:WGME34:,WGME34KG=:WGME34KG:,WGME35=:WGME35:,WGME35KG=:WGME35KG:,WGME36=:WGME36:,WGME36KG=:WGME36KG:,WGME37=:WGME37:,WGME37KG=:WGME37KG:,WGME40=:WGME40:,WGME40KG=:WGME40KG:,WGME41=:WGME41:,WGME41KG=:WGME41KG:,WGME42=:WGME42:,WGME42KG=:WGME42KG:,WGME43=:WGME43:,WGME43KG=:WGME43KG:,WGME46=:WGME46:,WGME46KG=:WGME46KG:,WGME47=:WGME47:,WGME47KG=:WGME47KG:,WGME48=:WGME48:,WGME48KG=:WGME48KG:,WGME49=:WGME49:,WGME49KG=:WGME49KG:,WGME50=:WGME50:,WGME50KG=:WGME50KG:,WGME51=:WGME51:,WGME51KG=:WGME51KG:,WGME52=:WGME52:,WGME52KG=:WGME52KG:,WGME53=:WGME53:,WGME53KG=:WGME53KG:,WGME55=:WGME55:,WGME55KG=:WGME55KG:,WGME73=:WGME73:,WGME73KG=:WGME73KG:,WGME76=:WGME76:,WGME76KG=:WGME76KG:,WGME79=:WGME79:,WGME79KG=:WGME79KG:,WGME80=:WGME80:,WGME88=:WGME88:,WGME89=:WGME89:,WGME90=:WGME90:,WGME90KG=:WGME90KG:,WGME91=:WGME91:,WGME91KG=:WGME91KG:,WGMER04=:WGMER04:,WGMER05=:WGMER05:,WGRESV1=:WGRESV1:,WGRESV2=:WGRESV2:,WGRESV3=:WGRESV3:,WGRESV4=:WGRESV4:,WGRESV5=:WGRESV5:,WGBSTA=:WGBSTA:,WGBSTAKG=:WGBSTAKG:,WGBSTAN=:WGBSTAN:,WGBSTANKG=:WGBSTANKG:,WGMEZUTEI=:WGMEZUTEI:,WGMEZUTEIKG=:WGMEZUTEIKG:,WGMER02=:WGMER02:,WGMER02KG=:WGMER02KG:,WGBSTKEN=:WGBSTKEN:,WGBSTKENKG=:WGBSTKENKG:,WGBSTKZU=:WGBSTKZU:,WGBSTKZUKG=:WGBSTKZUKG:,WGBSTKMA=:WGBSTKMA:,WGBSTKMAKG=:WGBSTKMAKG:,WGBSTKME=:WGBSTKME:,WGBSTKMEKG=:WGBSTKMEKG:,WGBSTMA=:WGBSTMA:,WGBSTMAKG=:WGBSTMAKG:,WGBSTME=:WGBSTME:,WGBSTMEKG=:WGBSTMEKG:,WGBSTVMA=:WGBSTVMA:,WGBSTVMAKG=:WGBSTVMAKG:,WGBSTVME=:WGBSTVME:,WGBSTVMEKG=:WGBSTVMEKG:,WGMEIV=:WGMEIV:,WGMEIVKG=:WGMEIVKG:,WGINDAT=:WGINDAT:,WGINBST=:WGINBST:,WGINBSTKG=:WGINBSTKG:,WGINALT=:WGINALT:,WGINALTKG=:WGINALTKG:,WGEKPRMA=:WGEKPRMA:,WGEKPRME=:WGEKPRME:,WGEKPRZU=:WGEKPRZU:,WGVRPR=:WGVRPR:,WGDLABST=:WGDLABST:,WGDLABSTKG=:WGDLABSTKG:,WGDLATAG=:WGDLATAG:,WGMINBST=:WGMINBST:,WGMINBSTKG=:WGMINBSTKG:,WGMAXBST=:WGMAXBST:,WGMAXBSTKG=:WGMAXBSTKG:,WGFERTKZ=:WGFERTKZ:,WGBRT=:WGBRT:,WGGRQM=:WGGRQM:,WGGRLFD=:WGGRLFD:,WGUEBER=:WGUEBER:,WGAENDZL=:WGAENDZL:,WGAENB=:WGAENB:,WGAEND=:WGAEND:,WGNEUB=:WGNEUB:,WGNEUD=:WGNEUD:,WGDART=:WGDART:,WGDVAR=:WGDVAR:,WGFILLER=:WGFILLER:"
                           + " WHERE    WGMANDANT=:WGMANDANT: AND WGSA=:WGSA: AND WGKUNDNR=:WGKUNDNR: AND WGWERK=:WGWERK: AND WGABT=:WGABT: AND WGWAKZ=:WGWAKZ: AND WGART=:WGART: AND WGVAR=:WGVAR:"
                       + "  AND WGFARBE=:WGFARBE: AND WGBESCHICH=:WGBESCHICH: AND WGDESS=:WGDESS: AND WGCOLORIT=:WGCOLORIT:   AND WGZUSTAND=:WGZUSTAND: AND WGZENSUR=:WGZENSUR: AND WGZENSURKZ=:WGZENSURKZ: AND WGLO=:WGLO:"
                    + " AND WGMJJ=:WGMJJ: AND WGMM=:WGMM: ";
                    or1.CommandText = INTEXDBC.InjectData(or1.CommandText, dwData);
                    break;
            }
            Connect2Proxy(or1);
        }
    }
}
